PC Plus SuperCD (UK) 1998 August

home *** CD-ROM | disk | FTP | other *** search
/ PC Plus SuperCD (UK) 1998 August / PC Plus SuperCD 50b Issue 142 (CD142b) (August 1998).iso / trial / ability / ABSPSMP.Z / Finance.aws < prev next >
Microsoft Compound Document | 1998-03-12 | 15.0 KB
open in:
MacOS 8.1 extracted |
Win98 extracted |
DOS extracted
browse contents |
view JSON data |
view as text

This file was processed as: Microsoft Compound Document (archive/msCompound).
Confidence	Program	Detection	Match Type	Support
`40%`	dexvert	Microsoft Compound Document `(archive/msCompound)`	magic	Supported
`10%`	dexvert	Microsoft Works Document/Spreadsheet `(document/microsoftWorks)`	magic	Supported
`100%`	file	Composite Document File V2 Document, Little Endian, Os: Windows, Version 4.10, Code page: 1252, Revision Number: 10, Total Editing Time: 01:13:42, Last Saved Time/Date: Thu Mar 12 13:46:03 1998, Create Time/Date: Mon Mar 2 13:28:08 1998, Number of Pages: 2, Number of Words: 0, Number of Characters: 0, Name of Creating Application: Ability Spreadsheet, Security: 0	default (weak)
`99%`	file	OLE 2 Compound Document, v3.62, SecID 0, Mini FAT start sector 0x5 : UNKNOWN, clsid 0xa07ab5ed24f7ce118bff00608cf67596 {EDB57AA0-F724-11CE-8BFF-00608CF67596} with names Contents SummaryInformation Spreadsheet ��	default
`98%`	file	data	default
`100%`	TrID	Generic OLE2 / Multistream Compound	default
`1%`	dearkID	deark: cfb	default (weak)
`100%`	lsar	CFBF	default
`100%`	gt2	POIFS Dokument (Winword, Excel, Starwriter, ...)	default (weak)
`100%`	detectItEasy	Format: CFBF(3.62)	default (weak)
`100%`	detectItEasy	Format: Microsoft Office(97-2003)	default (weak)
`100%`	xdgMime	application/x-ole-storage	default (weak)
hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| d0 cf 11 e0 a1 b1 1a e1 | 00 00 00 00 00 00 00 00 |........|........|
|00000010| 00 00 00 00 00 00 00 00 | 3e 00 03 00 fe ff 09 00 |........|>.......|
|00000020| 06 00 00 00 00 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 10 00 00 05 00 00 00 |........|........|
|00000040| 01 00 00 00 fe ff ff ff | 00 00 00 00 01 00 00 00 |........|........|
|00000050| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000060| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000070| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000080| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000090| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000000a0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000000b0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000000c0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000000d0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000000e0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000000f0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000100| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000110| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000120| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000130| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000140| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000150| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000160| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000170| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000180| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000190| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000001a0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000001b0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000001c0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000001d0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000001e0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000001f0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000200| 52 00 6f 00 6f 00 74 00 | 20 00 45 00 6e 00 74 00 |R.o.o.t.| .E.n.t.|
|00000210| 72 00 79 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |r.y.....|........|
|00000220| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000230| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000240| 16 00 05 00 ff ff ff ff | ff ff ff ff 03 00 00 00 |........|........|
|00000250| a0 7a b5 ed 24 f7 ce 11 | 8b ff 00 60 8c f6 75 96 |.z..$...|...`..u.|
|00000260| 00 00 00 00 a0 48 e5 9f | 45 4c bd 01 20 17 44 33 |.....H..|EL.. .D3|
|00000270| bd 4d bd 01 06 00 00 00 | 00 02 00 00 00 00 00 00 |.M......|........|
|00000280| 43 00 6f 00 6e 00 74 00 | 65 00 6e 00 74 00 73 00 |C.o.n.t.|e.n.t.s.|
|00000290| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002c0| 12 00 02 00 ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000002d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002f0| 00 00 00 00 07 00 00 00 | 0c 00 00 00 00 00 00 00 |........|........|
|00000300| 05 00 53 00 75 00 6d 00 | 6d 00 61 00 72 00 79 00 |..S.u.m.|m.a.r.y.|
|00000310| 49 00 6e 00 66 00 6f 00 | 72 00 6d 00 61 00 74 00 |I.n.f.o.|r.m.a.t.|
|00000320| 69 00 6f 00 6e 00 00 00 | 00 00 00 00 00 00 00 00 |i.o.n...|........|
|00000330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000340| 28 00 02 00 ff ff ff ff | ff ff ff ff ff ff ff ff |(.......|........|
|00000350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000370| 00 00 00 00 00 00 00 00 | b1 01 00 00 00 00 00 00 |........|........|
|00000380| 53 00 70 00 72 00 65 00 | 61 00 64 00 73 00 68 00 |S.p.r.e.|a.d.s.h.|
|00000390| 65 00 65 00 74 00 00 00 | 00 00 00 00 00 00 00 00 |e.e.t...|........|
|000003a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003c0| 18 00 02 01 01 00 00 00 | 02 00 00 00 ff ff ff ff |........|........|
|000003d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000003f0| 00 00 00 00 0a 00 00 00 | 19 1a 00 00 00 00 00 00 |........|........|
|00000400| fe ff ff ff fd ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000410| ff ff ff ff fe ff ff ff | fe ff ff ff ff ff ff ff |........|........|
|00000420| ff ff ff ff ff ff ff ff | 0b 00 00 00 0c 00 00 00 |........|........|
|00000430| 0d 00 00 00 0e 00 00 00 | 0f 00 00 00 10 00 00 00 |........|........|
|00000440| 16 00 00 00 ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000450| ff ff ff ff ff ff ff ff | 17 00 00 00 18 00 00 00 |........|........|
|00000460| 19 00 00 00 1a 00 00 00 | 1b 00 00 00 1c 00 00 00 |........|........|
|00000470| fe ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000480| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000490| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000004a0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000004b0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000004c0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000004d0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000004e0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000004f0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000500| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000510| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000520| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000530| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000540| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000550| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000560| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000570| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000580| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000590| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000005a0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000005b0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000005c0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000005d0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000005e0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000005f0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000600| 52 00 6f 00 6f 00 74 00 | 20 00 45 00 6e 00 74 00 |R.o.o.t.| .E.n.t.|
|00000610| 72 00 79 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |r.y.....|........|
|00000620| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000630| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000640| 16 00 05 00 ff ff ff ff | ff ff ff ff 03 00 00 00 |........|........|
|00000650| a0 7a b5 ed 24 f7 ce 11 | 8b ff 00 60 8c f6 75 96 |.z..$...|...`..u.|
|00000660| 00 00 00 00 a0 48 e5 9f | 45 4c bd 01 60 ef 3a 33 |.....H..|EL..`.:3|
|00000670| bd 4d bd 01 06 00 00 00 | 00 02 00 00 00 00 00 00 |.M......|........|
|00000680| 43 00 6f 00 6e 00 74 00 | 65 00 6e 00 74 00 73 00 |C.o.n.t.|e.n.t.s.|
|00000690| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006c0| 12 00 02 00 ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000006d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006f0| 00 00 00 00 07 00 00 00 | 0c 00 00 00 00 00 00 00 |........|........|
|00000700| 05 00 53 00 75 00 6d 00 | 6d 00 61 00 72 00 79 00 |..S.u.m.|m.a.r.y.|
|00000710| 49 00 6e 00 66 00 6f 00 | 72 00 6d 00 61 00 74 00 |I.n.f.o.|r.m.a.t.|
|00000720| 69 00 6f 00 6e 00 00 00 | 00 00 00 00 00 00 00 00 |i.o.n...|........|
|00000730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000740| 28 00 02 00 ff ff ff ff | ff ff ff ff ff ff ff ff |(.......|........|
|00000750| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000770| 00 00 00 00 00 00 00 00 | b1 01 00 00 00 00 00 00 |........|........|
|00000780| 53 00 70 00 72 00 65 00 | 61 00 64 00 73 00 68 00 |S.p.r.e.|a.d.s.h.|
|00000790| 65 00 65 00 74 00 00 00 | 00 00 00 00 00 00 00 00 |e.e.t...|........|
|000007a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007c0| 18 00 02 01 01 00 00 00 | 02 00 00 00 ff ff ff ff |........|........|
|000007d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000007f0| 00 00 00 00 04 00 00 00 | 19 1a 00 00 00 00 00 00 |........|........|
|00000800| ff ff ff ff ff ff ff ff | fe ff ff ff fd ff ff ff |........|........|
|00000810| 07 00 00 00 fe ff ff ff | fe ff ff ff 08 00 00 00 |........|........|
|00000820| 09 00 00 00 11 00 00 00 | ff ff ff ff ff ff ff ff |........|........|
|00000830| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000840| ff ff ff ff 12 00 00 00 | 13 00 00 00 14 00 00 00 |........|........|
|00000850| 15 00 00 00 1d 00 00 00 | ff ff ff ff ff ff ff ff |........|........|
|00000860| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000870| ff ff ff ff 1e 00 00 00 | 1f 00 00 00 20 00 00 00 |........|.... ...|
|00000880| 21 00 00 00 fe ff ff ff | ff ff ff ff ff ff ff ff |!.......|........|
|00000890| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000008a0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000008b0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000008c0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000008d0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000008e0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000008f0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000900| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000910| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000920| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000930| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000940| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000950| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000960| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000970| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000980| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000990| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000009a0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000009b0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000009c0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000009d0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000009e0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000009f0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000a00| 00 01 04 00 00 00 00 00 | 02 01 04 00 87 02 00 00 |........|........|
|00000a10| 41 01 02 00 09 00 42 01 | 01 00 01 29 01 10 00 60 |A.....B.|...)...`|
|00000a20| 00 00 00 78 00 00 00 60 | 00 00 00 78 00 00 00 2c |...x...`|...x...,|
|00000a30| 01 01 00 00 2d 01 02 00 | 00 00 2e 01 3d 00 00 08 |....-...|....=...|
|00000a40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 90 |........|........|
|00000a50| 01 00 00 00 00 00 01 00 | 00 00 00 41 72 69 61 6c |........|...Arial|
|00000a60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a70| 00 00 00 00 00 00 00 00 | 00 00 00 2d 01 04 00 01 |........|...-....|
|00000a80| 26 46 00 2e 01 3d 00 01 | 08 00 00 00 00 00 00 00 |&F...=..|........|
|00000a90| 00 00 00 00 00 00 00 00 | 90 01 00 00 00 00 00 01 |........|........|
|00000aa0| 00 00 00 00 41 72 69 61 | 6c 00 00 00 00 00 00 00 |....Aria|l.......|
|00000ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ac0| 00 00 00 00 2d 01 02 00 | 02 00 2e 01 3d 00 02 08 |....-...|....=...|
|00000ad0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 90 |........|........|
|00000ae0| 01 00 00 00 00 00 01 00 | 00 00 00 41 72 69 61 6c |........|...Arial|
|00000af0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b00| 00 00 00 00 00 00 00 00 | 00 00 00 2f 01 04 00 30 |........|.../...0|
|00000b10| 00 00 00 30 01 00 00 2c | 01 01 00 01 2d 01 02 00 |...0...,|....-...|
|00000b20| 00 00 2e 01 3d 00 00 08 | 00 00 00 00 00 00 00 00 |....=...|........|
|00000b30| 00 00 00 00 00 00 00 90 | 01 00 00 00 00 00 01 00 |........|........|
|00000b40| 00 00 00 41 72 69 61 6c | 00 00 00 00 00 00 00 00 |...Arial|........|
|00000b50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b60| 00 00 00 2d 01 04 00 01 | 26 50 00 2e 01 3d 00 01 |...-....|&P...=..|
|00000b70| 08 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b80| 90 01 00 00 00 00 00 01 | 00 00 00 00 41 72 69 61 |........|....Aria|
|00000b90| 6c 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |l.......|........|
|00000ba0| 00 00 00 00 00 00 00 00 | 00 00 00 00 2d 01 02 00 |........|....-...|
|00000bb0| 02 00 2e 01 3d 00 02 08 | 00 00 00 00 00 00 00 00 |....=...|........|
|00000bc0| 00 00 00 00 00 00 00 90 | 01 00 00 00 00 00 01 00 |........|........|
|00000bd0| 00 00 00 41 72 69 61 6c | 00 00 00 00 00 00 00 00 |...Arial|........|
|00000be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000bf0| 00 00 00 2f 01 04 00 30 | 00 00 00 30 01 00 00 2a |.../...0|...0...*|
|00000c00| 01 00 00 00 02 00 00 00 | 03 00 00 00 04 00 00 00 |........|........|
|00000c10| 05 00 00 00 06 00 00 00 | fe ff ff ff fe ff ff ff |........|........|
|00000c20| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000c30| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000c40| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000c50| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000c60| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000c70| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000c80| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000c90| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000ca0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000cb0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000cc0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000cd0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000ce0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000cf0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000d00| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000d10| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000d20| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000d30| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000d40| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000d50| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000d60| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000d70| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000d80| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000d90| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000da0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000db0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000dc0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000dd0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000de0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000df0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000e00| fe ff 00 00 04 0a 02 00 | e0 85 9f f2 f9 4f 68 10 |........|.....Oh.|
|00000e10| ab 91 08 00 2b 27 b3 d9 | 01 00 00 00 e0 85 9f f2 |....+'..|........|
|00000e20| f9 4f 68 10 ab 91 08 00 | 2b 27 b3 d9 30 00 00 00 |.Oh.....|+'..0...|
|00000e30| 81 01 00 00 13 00 00 00 | 01 00 00 00 a0 00 00 00 |........|........|
|00000e40| 02 00 00 00 a8 00 00 00 | 03 00 00 00 b4 00 00 00 |........|........|
|00000e50| 04 00 00 00 c0 00 00 00 | 05 00 00 00 cc 00 00 00 |........|........|
|00000e60| 06 00 00 00 d8 00 00 00 | 07 00 00 00 e4 00 00 00 |........|........|
|00000e70| 08 00 00 00 f0 00 00 00 | 09 00 00 00 fc 00 00 00 |........|........|
|00000e80| 0a 00 00 00 08 01 00 00 | 0b 00 00 00 14 01 00 00 |........|........|
|00000e90| 0d 00 00 00 20 01 00 00 | 0c 00 00 00 2c 01 00 00 |.... ...|....,...|
|00000ea0| 0e 00 00 00 38 01 00 00 | 0f 00 00 00 40 01 00 00 |....8...|....@...|
|00000eb0| 10 00 00 00 48 01 00 00 | 12 00 00 00 50 01 00 00 |....H...|....P...|
|00000ec0| 13 00 00 00 6c 01 00 00 | 00 00 00 00 74 01 00 00 |....l...|....t...|
|00000ed0| 02 00 00 00 e4 04 00 00 | 1e 00 00 00 01 00 00 00 |........|........|
|00000ee0| 00 00 00 00 1e 00 00 00 | 01 00 00 00 00 00 00 00 |........|........|
|00000ef0| 1e 00 00 00 01 00 00 00 | 00 00 00 00 1e 00 00 00 |........|........|
|00000f00| 01 00 00 00 00 00 00 00 | 1e 00 00 00 01 00 00 00 |........|........|
|00000f10| 00 00 00 00 1e 00 00 00 | 01 00 00 00 00 00 00 00 |........|........|
|00000f20| 1e 00 00 00 01 00 00 00 | 00 00 00 00 1e 00 00 00 |........|........|
|00000f30| 03 00 00 00 31 30 00 00 | 40 00 00 00 a0 6b 02 4c |....10..|@....k.L|
|00000f40| 0a 00 00 00 40 00 00 00 | 00 00 00 00 00 00 00 00 |....@...|........|
|00000f50| 40 00 00 00 00 fa a9 32 | bd 4d bd 01 40 00 00 00 |@......2|.M..@...|
|00000f60| c0 f5 e3 09 df 45 bd 01 | 03 00 00 00 02 00 00 00 |.....E..|........|
|00000f70| 03 00 00 00 00 00 00 00 | 03 00 00 00 00 00 00 00 |........|........|
|00000f80| 1e 00 00 00 14 00 00 00 | 41 62 69 6c 69 74 79 20 |........|Ability |
|00000f90| 53 70 72 65 61 64 73 68 | 65 65 74 00 03 00 00 00 |Spreadsh|eet.....|
|00000fa0| 00 00 00 00 01 00 00 00 | 00 00 00 00 01 00 00 00 |........|........|
|00000fb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fc0| 00 10 00 00 01 10 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001000| 01 04 00 01 00 00 00 2b | 01 01 00 01 25 01 01 00 |.......+|....%...|
|00001010| 00 26 01 01 00 01 27 01 | 01 00 00 28 01 02 00 64 |.&....'.|...(...d|
|00001020| 00 23 01 01 00 01 19 01 | 00 00 1a 01 02 00 50 00 |.#......|......P.|
|00001030| 1b 01 02 00 10 00 06 00 | 04 00 00 00 00 00 0a 00 |........|........|
|00001040| 01 00 00 0b 00 01 00 00 | 0c 00 01 00 00 0f 00 01 |........|........|
|00001050| 00 00 10 00 01 00 00 31 | 01 0a 00 01 00 00 00 41 |.......1|.......A|
|00001060| 72 69 61 6c 00 05 01 02 | 00 01 00 06 01 01 00 09 |rial....|........|
|00001070| 07 01 01 00 01 08 01 01 | 00 00 09 01 01 00 00 0a |........|........|
|00001080| 01 01 00 00 0b 01 01 00 | 00 0c 01 01 00 00 0d 01 |........|........|
|00001090| 04 00 ff ff ff 00 0e 01 | 01 00 00 0f 01 01 00 00 |........|........|
|000010a0| 10 01 01 00 00 11 01 01 | 00 00 12 01 01 00 10 13 |........|........|
|000010b0| 01 01 00 10 14 01 01 00 | 10 15 01 01 00 10 16 01 |........|........|
|000010c0| 01 00 00 17 01 01 00 02 | 18 01 01 00 00 1c 01 00 |........|........|
|000010d0| 00 1d 01 01 00 00 1f 01 | 02 00 76 00 21 01 00 00 |........|..v.!...|
|000010e0| 03 01 03 00 00 00 00 06 | 01 01 00 0a 08 01 01 00 |........|........|
|000010f0| 01 09 01 01 00 02 04 00 | 1a 00 42 61 6e 6b 20 54 |........|..Bank T|
|00001100| 72 61 6e 73 61 63 74 69 | 6f 6e 20 41 6e 61 6c 79 |ransacti|on Analy|
|00001110| 73 69 73 00 04 01 00 00 | 03 01 03 00 00 02 00 07 |sis.....|........|
|00001120| 01 01 00 00 0c 01 01 00 | 04 04 00 50 00 54 68 69 |........|...P.Thi|
|00001130| 73 20 73 70 72 65 61 64 | 73 68 65 65 74 20 73 68 |s spread|sheet sh|
|00001140| 6f 77 73 20 68 6f 77 20 | 74 68 65 20 62 75 69 6c |ows how |the buil|
|00001150| 74 2d 69 6e 20 64 61 74 | 61 62 61 73 65 20 66 75 |t-in dat|abase fu|
|00001160| 6e 63 74 69 6f 6e 73 20 | 63 61 6e 20 70 75 6c 6c |nctions |can pull|
|00001170| 20 69 6e 66 6f 72 6d 61 | 74 69 6f 6e 00 04 01 00 | informa|tion....|
|00001180| 00 03 01 03 00 00 03 00 | 07 01 01 00 00 0c 01 01 |........|........|
|00001190| 00 04 04 00 61 00 64 69 | 72 65 63 74 6c 79 20 66 |....a.di|rectly f|
|000011a0| 72 6f 6d 20 64 61 74 61 | 62 61 73 65 2e 20 54 68 |rom data|base. Th|
|000011b0| 65 20 6d 61 69 6e 20 62 | 6f 64 79 20 6f 66 20 74 |e main b|ody of t|
|000011c0| 68 65 20 74 61 62 6c 65 | 20 63 6f 6e 74 61 69 6e |he table| contain|
|000011d0| 73 20 61 20 73 65 72 69 | 65 73 20 6f 66 20 6c 69 |s a seri|es of li|
|000011e0| 6e 6b 73 20 74 68 61 74 | 20 63 6f 6e 64 69 74 69 |nks that| conditi|
|000011f0| 6f 6e 61 6c 6c 79 00 04 | 01 00 00 03 01 03 00 00 |onally..|........|
|00001200| 04 00 07 01 01 00 00 0c | 01 01 00 04 04 00 65 00 |........|......e.|
|00001210| 72 65 74 75 72 6e 20 6d | 61 74 63 68 69 6e 67 20 |return m|atching |
|00001220| 76 61 6c 75 65 73 20 66 | 72 6f 6d 20 74 68 65 20 |values f|rom the |
|00001230| 64 61 74 61 62 61 73 65 | 20 66 6f 72 20 74 68 65 |database| for the|
|00001240| 20 63 6f 72 72 65 73 70 | 6f 6e 64 69 6e 67 20 74 | corresp|onding t|
|00001250| 72 61 6e 73 61 63 74 69 | 6f 6e 20 74 79 70 65 20 |ransacti|on type |
|00001260| 61 6e 64 20 6d 6f 6e 74 | 68 2e 20 53 74 61 6e 64 |and mont|h. Stand|
|00001270| 61 72 64 20 00 04 01 00 | 00 03 01 03 00 00 05 00 |ard ....|........|
|00001280| 07 01 01 00 00 0c 01 01 | 00 04 04 00 68 00 73 70 |........|....h.sp|
|00001290| 72 65 61 64 73 68 65 65 | 74 20 66 75 6e 63 74 69 |readshee|t functi|
|000012a0| 6f 6e 73 20 73 75 63 68 | 20 61 73 20 3d 53 55 4d |ons such| as =SUM|
|000012b0| 20 63 61 6e 20 74 68 65 | 6e 20 62 65 20 75 73 65 | can the|n be use|
|000012c0| 64 20 74 6f 20 70 72 6f | 76 69 64 65 20 67 72 6f |d to pro|vide gro|
|000012d0| 75 70 20 74 6f 74 61 6c | 73 20 61 6e 64 20 74 68 |up total|s and th|
|000012e0| 65 6e 20 72 6f 77 2f 63 | 6f 6c 75 6d 6e 20 74 6f |en row/c|olumn to|
|000012f0| 74 61 6c 73 2e 00 04 01 | 00 00 03 01 03 00 00 07 |tals....|........|
|00001300| 00 08 01 01 00 01 04 00 | 12 00 54 72 61 6e 73 61 |........|..Transa|
|00001310| 63 74 69 6f 6e 20 54 79 | 70 65 73 00 04 01 00 00 |ction Ty|pes.....|
|00001320| 03 01 03 00 00 08 00 04 | 00 08 00 52 65 63 65 69 |........|...Recei|
|00001330| 70 74 00 04 01 00 00 03 | 01 03 00 00 09 00 04 00 |pt......|........|
|00001340| 0e 00 44 69 72 65 63 74 | 20 44 65 62 69 74 73 00 |..Direct| Debits.|
|00001350| 04 01 00 00 03 01 03 00 | 00 0a 00 04 00 11 00 43 |........|.......C|
|00001360| 61 73 68 20 57 69 74 68 | 64 72 61 77 61 6c 73 00 |ash With|drawals.|
|00001370| 04 01 00 00 03 01 03 00 | 00 0b 00 04 00 07 00 43 |........|.......C|
|00001380| 68 65 63 6b 73 00 04 01 | 00 00 03 01 03 00 00 0d |hecks...|........|
|00001390| 00 04 00 0b 00 4e 65 74 | 20 50 72 6f 66 69 74 00 |.....Net| Profit.|
|000013a0| 04 01 00 00 03 01 03 00 | 00 0f 00 06 01 01 00 0a |........|........|
|000013b0| 07 01 01 00 00 08 01 01 | 00 01 09 01 01 00 02 0c |........|........|
|000013c0| 01 01 00 04 04 00 0d 00 | 48 6f 77 20 69 74 20 77 |........|How it w|
|000013d0| 6f 72 6b 73 00 04 01 00 | 00 03 01 03 00 00 10 00 |orks....|........|
|000013e0| 07 01 01 00 00 0c 01 01 | 00 04 02 00 00 00 04 01 |........|........|
|000013f0| 00 00 03 01 03 00 00 11 | 00 07 01 01 00 00 0c 01 |........|........|
|00001400| 01 00 04 04 00 46 00 54 | 68 65 20 66 6f 72 6d 75 |.....F.T|he formu|
|00001410| 6c 61 20 75 73 65 64 20 | 74 6f 20 65 78 74 72 61 |la used |to extra|
|00001420| 63 74 20 74 68 65 20 52 | 65 63 65 69 70 74 73 20 |ct the R|eceipts |
|00001430| 66 6f 72 20 46 65 62 75 | 61 72 79 20 6c 6f 6f 6b |for Febu|ary look|
|00001440| 73 20 6c 69 6b 65 20 74 | 68 69 73 3a 00 04 01 00 |s like t|his:....|
|00001450| 00 03 01 03 00 00 12 00 | 07 01 01 00 00 0c 01 01 |........|........|
|00001460| 00 04 02 00 00 00 04 01 | 00 00 03 01 03 00 00 13 |........|........|
|00001470| 00 07 01 01 00 00 08 01 | 01 00 01 0c 01 01 00 04 |........|........|
|00001480| 04 00 64 00 20 20 20 3d | 20 53 55 4d 20 28 44 42 |..d.   =| SUM (DB|
|00001490| 53 51 4c 46 49 4c 54 45 | 52 20 28 22 53 61 6d 70 |SQLFILTE|R ("Samp|
|000014a0| 6c 65 2e 61 64 62 22 2c | 20 22 42 61 6e 6b 52 65 |le.adb",| "BankRe|
|000014b0| 63 6f 72 64 73 22 2c 20 | 22 54 79 70 65 3d 27 52 |cords", |"Type='R|
|000014c0| 65 63 65 69 70 74 27 20 | 41 4e 44 20 6d 6f 6e 74 |eceipt' |AND mont|
|000014d0| 68 28 54 64 61 74 65 29 | 3d 32 22 2c 20 22 41 6d |h(Tdate)|=2", "Am|
|000014e0| 6f 75 6e 74 22 29 29 00 | 04 01 00 00 03 01 03 00 |ount")).|........|
|000014f0| 00 14 00 07 01 01 00 00 | 0c 01 01 00 04 02 00 00 |........|........|
|00001500| 00 04 01 00 00 03 01 03 | 00 00 15 00 07 01 01 00 |........|........|
|00001510| 00 0c 01 01 00 04 04 00 | 4e 00 54 68 65 72 65 20 |........|N.There |
|00001520| 61 72 65 20 66 6f 75 72 | 20 70 61 72 61 72 6d 65 |are four| pararme|
|00001530| 74 65 72 73 20 75 73 65 | 64 20 74 6f 20 62 75 69 |ters use|d to bui|
|00001540| 6c 64 20 74 68 65 20 44 | 42 53 51 4c 46 49 4c 54 |ld the D|BSQLFILT|
|00001550| 45 52 20 66 75 6e 63 74 | 69 6f 6e 20 61 73 20 66 |ER funct|ion as f|
|00001560| 6f 6c 6c 6f 77 73 3a 00 | 04 01 00 00 03 01 03 00 |ollows:.|........|
|00001570| 00 16 00 07 01 01 00 00 | 0c 01 01 00 04 02 00 00 |........|........|
|00001580| 00 04 01 00 00 03 01 03 | 00 00 17 00 07 01 01 00 |........|........|
|00001590| 00 0c 01 01 00 04 02 00 | 00 00 04 01 00 00 03 01 |........|........|
|000015a0| 03 00 00 18 00 07 01 01 | 00 00 0c 01 01 00 04 02 |........|........|
|000015b0| 00 00 00 04 01 00 00 03 | 01 03 00 00 19 00 07 01 |........|........|
|000015c0| 01 00 00 0c 01 01 00 04 | 02 00 00 00 04 01 00 00 |........|........|
|000015d0| 03 01 03 00 00 1a 00 07 | 01 01 00 00 0c 01 01 00 |........|........|
|000015e0| 04 02 00 00 00 04 01 00 | 00 03 01 03 00 00 1b 00 |........|........|
|000015f0| 07 01 01 00 00 0c 01 01 | 00 04 02 00 00 00 04 01 |........|........|
|00001600| 00 01 04 00 00 00 00 00 | 02 01 04 00 87 02 00 00 |........|........|
|00001610| 41 01 02 00 09 00 42 01 | 01 00 01 29 01 10 00 60 |A.....B.|...)...`|
|00001620| 00 00 00 78 00 00 00 60 | 00 00 00 78 00 00 00 2c |...x...`|...x...,|
|00001630| 01 01 00 00 2d 01 02 00 | 00 00 2e 01 3d 00 00 08 |....-...|....=...|
|00001640| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 90 |........|........|
|00001650| 01 00 00 00 00 00 01 00 | 00 00 00 41 72 69 61 6c |........|...Arial|
|00001660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001670| 00 00 00 00 00 00 00 00 | 00 00 00 2d 01 04 00 01 |........|...-....|
|00001680| 26 46 00 2e 01 3d 00 01 | 08 00 00 00 00 00 00 00 |&F...=..|........|
|00001690| 00 00 00 00 00 00 00 00 | 90 01 00 00 00 00 00 01 |........|........|
|000016a0| 00 00 00 00 41 72 69 61 | 6c 00 00 00 00 00 00 00 |....Aria|l.......|
|000016b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016c0| 00 00 00 00 2d 01 02 00 | 02 00 2e 01 3d 00 02 08 |....-...|....=...|
|000016d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 90 |........|........|
|000016e0| 01 00 00 00 00 00 01 00 | 00 00 00 41 72 69 61 6c |........|...Arial|
|000016f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001700| 00 00 00 00 00 00 00 00 | 00 00 00 2f 01 04 00 30 |........|.../...0|
|00001710| 00 00 00 30 01 00 00 2c | 01 01 00 01 2d 01 02 00 |...0...,|....-...|
|00001720| 00 00 2e 01 3d 00 00 08 | 00 00 00 00 00 00 00 00 |....=...|........|
|00001730| 00 00 00 00 00 00 00 90 | 01 00 00 00 00 00 01 00 |........|........|
|00001740| 00 00 00 41 72 69 61 6c | 00 00 00 00 00 00 00 00 |...Arial|........|
|00001750| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001760| 00 00 00 2d 01 04 00 01 | 26 50 00 2e 01 3d 00 01 |...-....|&P...=..|
|00001770| 08 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001780| 90 01 00 00 00 00 00 01 | 00 00 00 00 41 72 69 61 |........|....Aria|
|00001790| 6c 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |l.......|........|
|000017a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 2d 01 02 00 |........|....-...|
|000017b0| 02 00 2e 01 3d 00 02 08 | 00 00 00 00 00 00 00 00 |....=...|........|
|000017c0| 00 00 00 00 00 00 00 90 | 01 00 00 00 00 00 01 00 |........|........|
|000017d0| 00 00 00 41 72 69 61 6c | 00 00 00 00 00 00 00 00 |...Arial|........|
|000017e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000017f0| 00 00 00 2f 01 04 00 30 | 00 00 00 30 01 00 00 2a |.../...0|...0...*|
|00001800| 01 04 00 01 00 00 00 2b | 01 01 00 01 25 01 01 00 |.......+|....%...|
|00001810| 00 26 01 01 00 01 27 01 | 01 00 00 28 01 02 00 64 |.&....'.|...(...d|
|00001820| 00 23 01 01 00 01 19 01 | 00 00 1a 01 02 00 50 00 |.#......|......P.|
|00001830| 1b 01 02 00 10 00 06 00 | 04 00 00 00 00 00 0a 00 |........|........|
|00001840| 01 00 00 0b 00 01 00 00 | 0c 00 01 00 00 0f 00 01 |........|........|
|00001850| 00 00 10 00 01 00 00 31 | 01 0a 00 01 00 00 00 41 |.......1|.......A|
|00001860| 72 69 61 6c 00 05 01 02 | 00 01 00 06 01 01 00 09 |rial....|........|
|00001870| 07 01 01 00 01 08 01 01 | 00 00 09 01 01 00 00 0a |........|........|
|00001880| 01 01 00 00 0b 01 01 00 | 00 0c 01 01 00 00 0d 01 |........|........|
|00001890| 04 00 ff ff ff 00 0e 01 | 01 00 00 0f 01 01 00 00 |........|........|
|000018a0| 10 01 01 00 00 11 01 01 | 00 00 12 01 01 00 10 13 |........|........|
|000018b0| 01 01 00 10 14 01 01 00 | 10 15 01 01 00 10 16 01 |........|........|
|000018c0| 01 00 00 17 01 01 00 02 | 18 01 01 00 00 1c 01 00 |........|........|
|000018d0| 00 1d 01 01 00 00 1f 01 | 02 00 76 00 21 01 00 00 |........|..v.!...|
|000018e0| 03 01 03 00 00 00 00 06 | 01 01 00 0a 08 01 01 00 |........|........|
|000018f0| 01 09 01 01 00 02 04 00 | 1a 00 42 61 6e 6b 20 54 |........|..Bank T|
|00001900| 72 61 6e 73 61 63 74 69 | 6f 6e 20 41 6e 61 6c 79 |ransacti|on Analy|
|00001910| 73 69 73 00 04 01 00 00 | 03 01 03 00 00 02 00 07 |sis.....|........|
|00001920| 01 01 00 00 0c 01 01 00 | 04 04 00 50 00 54 68 69 |........|...P.Thi|
|00001930| 73 20 73 70 72 65 61 64 | 73 68 65 65 74 20 73 68 |s spread|sheet sh|
|00001940| 6f 77 73 20 68 6f 77 20 | 74 68 65 20 62 75 69 6c |ows how |the buil|
|00001950| 74 2d 69 6e 20 64 61 74 | 61 62 61 73 65 20 66 75 |t-in dat|abase fu|
|00001960| 6e 63 74 69 6f 6e 73 20 | 63 61 6e 20 70 75 6c 6c |nctions |can pull|
|00001970| 20 69 6e 66 6f 72 6d 61 | 74 69 6f 6e 00 04 01 00 | informa|tion....|
|00001980| 00 03 01 03 00 00 03 00 | 07 01 01 00 00 0c 01 01 |........|........|
|00001990| 00 04 04 00 61 00 64 69 | 72 65 63 74 6c 79 20 66 |....a.di|rectly f|
|000019a0| 72 6f 6d 20 64 61 74 61 | 62 61 73 65 2e 20 54 68 |rom data|base. Th|
|000019b0| 65 20 6d 61 69 6e 20 62 | 6f 64 79 20 6f 66 20 74 |e main b|ody of t|
|000019c0| 68 65 20 74 61 62 6c 65 | 20 63 6f 6e 74 61 69 6e |he table| contain|
|000019d0| 73 20 61 20 73 65 72 69 | 65 73 20 6f 66 20 6c 69 |s a seri|es of li|
|000019e0| 6e 6b 73 20 74 68 61 74 | 20 63 6f 6e 64 69 74 69 |nks that| conditi|
|000019f0| 6f 6e 61 6c 6c 79 00 04 | 01 00 00 03 01 03 00 00 |onally..|........|
|00001a00| 04 00 07 01 01 00 00 0c | 01 01 00 04 04 00 65 00 |........|......e.|
|00001a10| 72 65 74 75 72 6e 20 6d | 61 74 63 68 69 6e 67 20 |return m|atching |
|00001a20| 76 61 6c 75 65 73 20 66 | 72 6f 6d 20 74 68 65 20 |values f|rom the |
|00001a30| 64 61 74 61 62 61 73 65 | 20 66 6f 72 20 74 68 65 |database| for the|
|00001a40| 20 63 6f 72 72 65 73 70 | 6f 6e 64 69 6e 67 20 74 | corresp|onding t|
|00001a50| 72 61 6e 73 61 63 74 69 | 6f 6e 20 74 79 70 65 20 |ransacti|on type |
|00001a60| 61 6e 64 20 6d 6f 6e 74 | 68 2e 20 53 74 61 6e 64 |and mont|h. Stand|
|00001a70| 61 72 64 20 00 04 01 00 | 00 03 01 03 00 00 05 00 |ard ....|........|
|00001a80| 07 01 01 00 00 0c 01 01 | 00 04 04 00 68 00 73 70 |........|....h.sp|
|00001a90| 72 65 61 64 73 68 65 65 | 74 20 66 75 6e 63 74 69 |readshee|t functi|
|00001aa0| 6f 6e 73 20 73 75 63 68 | 20 61 73 20 3d 53 55 4d |ons such| as =SUM|
|00001ab0| 20 63 61 6e 20 74 68 65 | 6e 20 62 65 20 75 73 65 | can the|n be use|
|00001ac0| 64 20 74 6f 20 70 72 6f | 76 69 64 65 20 67 72 6f |d to pro|vide gro|
|00001ad0| 75 70 20 74 6f 74 61 6c | 73 20 61 6e 64 20 74 68 |up total|s and th|
|00001ae0| 65 6e 20 72 6f 77 2f 63 | 6f 6c 75 6d 6e 20 74 6f |en row/c|olumn to|
|00001af0| 74 61 6c 73 2e 00 04 01 | 00 00 03 01 03 00 00 07 |tals....|........|
|00001b00| 00 08 01 01 00 01 04 00 | 12 00 54 72 61 6e 73 61 |........|..Transa|
|00001b10| 63 74 69 6f 6e 20 54 79 | 70 65 73 00 04 01 00 00 |ction Ty|pes.....|
|00001b20| 03 01 03 00 00 08 00 04 | 00 08 00 52 65 63 65 69 |........|...Recei|
|00001b30| 70 74 00 04 01 00 00 03 | 01 03 00 00 09 00 04 00 |pt......|........|
|00001b40| 0e 00 44 69 72 65 63 74 | 20 44 65 62 69 74 73 00 |..Direct| Debits.|
|00001b50| 04 01 00 00 03 01 03 00 | 00 0a 00 04 00 11 00 43 |........|.......C|
|00001b60| 61 73 68 20 57 69 74 68 | 64 72 61 77 61 6c 73 00 |ash With|drawals.|
|00001b70| 04 01 00 00 03 01 03 00 | 00 0b 00 04 00 07 00 43 |........|.......C|
|00001b80| 68 65 63 6b 73 00 04 01 | 00 00 03 01 03 00 00 0d |hecks...|........|
|00001b90| 00 04 00 0b 00 4e 65 74 | 20 50 72 6f 66 69 74 00 |.....Net| Profit.|
|00001ba0| 04 01 00 00 03 01 03 00 | 00 0f 00 06 01 01 00 0a |........|........|
|00001bb0| 07 01 01 00 00 08 01 01 | 00 01 09 01 01 00 02 0c |........|........|
|00001bc0| 01 01 00 04 04 00 0d 00 | 48 6f 77 20 69 74 20 77 |........|How it w|
|00001bd0| 6f 72 6b 73 00 04 01 00 | 00 03 01 03 00 00 10 00 |orks....|........|
|00001be0| 07 01 01 00 00 0c 01 01 | 00 04 02 00 00 00 04 01 |........|........|
|00001bf0| 00 00 03 01 03 00 00 11 | 00 07 01 01 00 00 0c 01 |........|........|
|00001c00| 01 00 04 04 00 46 00 54 | 68 65 20 66 6f 72 6d 75 |.....F.T|he formu|
|00001c10| 6c 61 20 75 73 65 64 20 | 74 6f 20 65 78 74 72 61 |la used |to extra|
|00001c20| 63 74 20 74 68 65 20 52 | 65 63 65 69 70 74 73 20 |ct the R|eceipts |
|00001c30| 66 6f 72 20 46 65 62 75 | 61 72 79 20 6c 6f 6f 6b |for Febu|ary look|
|00001c40| 73 20 6c 69 6b 65 20 74 | 68 69 73 3a 00 04 01 00 |s like t|his:....|
|00001c50| 00 03 01 03 00 00 12 00 | 07 01 01 00 00 0c 01 01 |........|........|
|00001c60| 00 04 02 00 00 00 04 01 | 00 00 03 01 03 00 00 13 |........|........|
|00001c70| 00 07 01 01 00 00 08 01 | 01 00 01 0c 01 01 00 04 |........|........|
|00001c80| 04 00 64 00 20 20 20 3d | 20 53 55 4d 20 28 44 42 |..d.   =| SUM (DB|
|00001c90| 53 51 4c 46 49 4c 54 45 | 52 20 28 22 53 61 6d 70 |SQLFILTE|R ("Samp|
|00001ca0| 6c 65 2e 61 64 62 22 2c | 20 22 42 61 6e 6b 52 65 |le.adb",| "BankRe|
|00001cb0| 63 6f 72 64 73 22 2c 20 | 22 54 79 70 65 3d 27 52 |cords", |"Type='R|
|00001cc0| 65 63 65 69 70 74 27 20 | 41 4e 44 20 6d 6f 6e 74 |eceipt' |AND mont|
|00001cd0| 68 28 54 64 61 74 65 29 | 3d 32 22 2c 20 22 41 6d |h(Tdate)|=2", "Am|
|00001ce0| 6f 75 6e 74 22 29 29 00 | 04 01 00 00 03 01 03 00 |ount")).|........|
|00001cf0| 00 14 00 07 01 01 00 00 | 0c 01 01 00 04 02 00 00 |........|........|
|00001d00| 00 04 01 00 00 03 01 03 | 00 00 15 00 07 01 01 00 |........|........|
|00001d10| 00 0c 01 01 00 04 04 00 | 4e 00 54 68 65 72 65 20 |........|N.There |
|00001d20| 61 72 65 20 66 6f 75 72 | 20 70 61 72 61 72 6d 65 |are four| pararme|
|00001d30| 74 65 72 73 20 75 73 65 | 64 20 74 6f 20 62 75 69 |ters use|d to bui|
|00001d40| 6c 64 20 74 68 65 20 44 | 42 53 51 4c 46 49 4c 54 |ld the D|BSQLFILT|
|00001d50| 45 52 20 66 75 6e 63 74 | 69 6f 6e 20 61 73 20 66 |ER funct|ion as f|
|00001d60| 6f 6c 6c 6f 77 73 3a 00 | 04 01 00 00 03 01 03 00 |ollows:.|........|
|00001d70| 00 16 00 07 01 01 00 00 | 0c 01 01 00 04 02 00 00 |........|........|
|00001d80| 00 04 01 00 00 03 01 03 | 00 00 17 00 07 01 01 00 |........|........|
|00001d90| 00 0c 01 01 00 04 02 00 | 00 00 04 01 00 00 03 01 |........|........|
|00001da0| 03 00 00 18 00 07 01 01 | 00 00 0c 01 01 00 04 02 |........|........|
|00001db0| 00 00 00 04 01 00 00 03 | 01 03 00 00 19 00 07 01 |........|........|
|00001dc0| 01 00 00 0c 01 01 00 04 | 02 00 00 00 04 01 00 00 |........|........|
|00001dd0| 03 01 03 00 00 1a 00 07 | 01 01 00 00 0c 01 01 00 |........|........|
|00001de0| 04 02 00 00 00 04 01 00 | 00 03 01 03 00 00 1b 00 |........|........|
|00001df0| 07 01 01 00 00 0c 01 01 | 00 04 02 00 00 00 04 01 |........|........|
|00001e00| 00 00 03 01 03 00 00 1c | 00 07 01 01 00 00 0c 01 |........|........|
|00001e10| 01 00 04 04 00 5f 00 54 | 68 69 73 20 72 65 74 75 |....._.T|his retu|
|00001e20| 72 6e 73 20 41 4c 4c 20 | 6d 61 74 63 68 69 6e 67 |rns ALL |matching|
|00001e30| 20 76 61 6c 75 65 73 20 | 66 72 6f 6d 20 74 68 65 | values |from the|
|00001e40| 20 64 61 74 61 62 61 73 | 65 20 2d 20 74 68 69 73 | databas|e - this|
|00001e50| 20 77 69 6c 6c 20 6e 6f | 72 6d 61 6c 6c 79 20 62 | will no|rmally b|
|00001e60| 65 20 6d 6f 72 65 20 74 | 68 61 6e 20 6f 6e 65 20 |e more t|han one |
|00001e70| 76 61 6c 75 65 00 04 01 | 00 00 03 01 03 00 00 1d |value...|........|
|00001e80| 00 07 01 01 00 00 0c 01 | 01 00 04 04 00 6a 00 61 |........|.....j.a|
|00001e90| 6e 64 20 63 61 6e 20 62 | 65 20 74 72 65 61 74 65 |nd can b|e treate|
|00001ea0| 64 20 6c 69 6b 65 20 61 | 6e 79 20 6f 74 68 65 72 |d like a|ny other|
|00001eb0| 20 73 65 72 69 65 73 20 | 69 6e 20 61 20 73 70 72 | series |in a spr|
|00001ec0| 65 61 64 73 68 65 65 74 | 20 28 69 74 20 63 61 6e |eadsheet| (it can|
|00001ed0| 20 62 65 20 73 75 6d 6d | 65 64 2c 20 63 6f 75 6e | be summ|ed, coun|
|00001ee0| 74 65 64 2c 20 69 6e 64 | 65 78 65 64 20 61 6e 64 |ted, ind|exed and|
|00001ef0| 20 73 6f 20 6f 6e 29 2e | 00 04 01 00 00 03 01 03 | so on).|........|
|00001f00| 00 00 1e 00 07 01 01 00 | 00 0c 01 01 00 04 04 00 |........|........|
|00001f10| 50 00 49 6e 20 74 68 69 | 73 20 63 61 73 65 20 74 |P.In thi|s case t|
|00001f20| 68 65 20 73 74 61 6e 64 | 61 72 64 20 73 70 72 65 |he stand|ard spre|
|00001f30| 61 64 73 68 65 65 74 20 | 66 75 6e 63 74 69 6f 6e |adsheet |function|
|00001f40| 20 53 55 4d 20 69 73 20 | 75 73 65 64 20 74 6f 20 | SUM is |used to |
|00001f50| 74 6f 74 61 6c 20 74 68 | 65 20 73 65 72 69 65 73 |total th|e series|
|00001f60| 2e 00 04 01 00 00 03 01 | 03 00 00 1f 00 07 01 01 |........|........|
|00001f70| 00 00 0c 01 01 00 04 02 | 00 00 00 04 01 00 00 03 |........|........|
|00001f80| 01 03 00 01 07 00 08 01 | 01 00 01 16 01 01 00 02 |........|........|
|00001f90| 04 00 04 00 4a 61 6e 00 | 04 01 00 00 03 01 03 00 |....Jan.|........|
|00001fa0| 01 08 00 05 00 0c 00 ae | 47 e1 7a 74 3e c4 40 00 |........|G.zt>.@.|
|00001fb0| 00 72 01 06 00 04 00 00 | 00 72 01 01 00 60 00 46 |.r......|.r...`.F|
|00001fc0| 53 55 4d 20 28 44 42 53 | 51 4c 46 49 4c 54 45 52 |SUM (DBS|QLFILTER|
|00001fd0| 20 28 22 53 61 6d 70 6c | 65 2e 61 64 62 22 2c 20 | ("Sampl|e.adb", |
|00001fe0| 22 42 61 6e 6b 52 65 63 | 6f 72 64 73 22 2c 20 22 |"BankRec|ords", "|
|00001ff0| 54 79 70 65 3d 27 52 65 | 63 65 69 70 74 27 20 41 |Type='Re|ceipt' A|
|00002000| 4e 44 20 6d 6f 6e 74 68 | 28 54 64 61 74 65 29 3d |ND month|(Tdate)=|
|00002010| 31 22 2c 20 22 41 6d 6f | 75 6e 74 22 29 29 00 04 |1", "Amo|unt"))..|
|00002020| 01 00 00 03 01 03 00 01 | 09 00 05 00 0c 00 15 ae |........|........|
|00002030| 47 e1 7a 7f ae c0 00 00 | 72 01 06 00 04 00 00 00 |G.z.....|r.......|
|00002040| 72 01 01 00 65 00 46 53 | 55 4d 20 28 44 42 53 51 |r...e.FS|UM (DBSQ|
|00002050| 4c 46 49 4c 54 45 52 20 | 28 22 53 61 6d 70 6c 65 |LFILTER |("Sample|
|00002060| 2e 61 64 62 22 2c 20 22 | 42 61 6e 6b 52 65 63 6f |.adb", "|BankReco|
|00002070| 72 64 73 22 2c 20 22 54 | 79 70 65 3d 27 44 69 72 |rds", "T|ype='Dir|
|00002080| 65 63 74 20 44 65 62 69 | 74 27 20 41 4e 44 20 6d |ect Debi|t' AND m|
|00002090| 6f 6e 74 68 28 54 64 61 | 74 65 29 3d 31 22 2c 20 |onth(Tda|te)=1", |
|000020a0| 22 41 6d 6f 75 6e 74 22 | 29 29 00 04 01 00 00 03 |"Amount"|))......|
|000020b0| 01 03 00 01 0a 00 05 00 | 0c 00 00 00 00 00 00 00 |........|........|
|000020c0| 69 c0 00 00 72 01 06 00 | 04 00 00 00 72 01 01 00 |i...r...|....r...|
|000020d0| 68 00 46 53 55 4d 20 28 | 44 42 53 51 4c 46 49 4c |h.FSUM (|DBSQLFIL|
|000020e0| 54 45 52 20 28 22 53 61 | 6d 70 6c 65 2e 61 64 62 |TER ("Sa|mple.adb|
|000020f0| 22 2c 20 22 42 61 6e 6b | 52 65 63 6f 72 64 73 22 |", "Bank|Records"|
|00002100| 2c 20 22 54 79 70 65 3d | 27 43 61 73 68 20 57 69 |, "Type=|'Cash Wi|
|00002110| 74 68 64 72 61 77 61 6c | 27 20 41 4e 44 20 6d 6f |thdrawal|' AND mo|
|00002120| 6e 74 68 28 54 64 61 74 | 65 29 3d 31 22 2c 20 22 |nth(Tdat|e)=1", "|
|00002130| 41 6d 6f 75 6e 74 22 29 | 29 00 04 01 00 00 03 01 |Amount")|).......|
|00002140| 03 00 01 0b 00 05 00 0c | 00 3e 0a d7 a3 70 ad 74 |........|.>...p.t|
|00002150| c0 00 00 72 01 06 00 04 | 00 00 00 72 01 01 00 5e |...r....|...r...^|
|00002160| 00 46 53 55 4d 20 28 44 | 42 53 51 4c 46 49 4c 54 |.FSUM (D|BSQLFILT|
|00002170| 45 52 20 28 22 53 61 6d | 70 6c 65 2e 61 64 62 22 |ER ("Sam|ple.adb"|
|00002180| 2c 20 22 42 61 6e 6b 52 | 65 63 6f 72 64 73 22 2c |, "BankR|ecords",|
|00002190| 20 22 54 79 70 65 3d 27 | 43 68 65 63 6b 27 20 41 | "Type='|Check' A|
|000021a0| 4e 44 20 6d 6f 6e 74 68 | 28 54 64 61 74 65 29 3d |ND month|(Tdate)=|
|000021b0| 31 22 2c 20 22 41 6d 6f | 75 6e 74 22 29 29 00 04 |1", "Amo|unt"))..|
|000021c0| 01 00 00 03 01 03 00 01 | 0c 00 02 00 00 00 06 00 |........|........|
|000021d0| 04 00 00 00 72 01 04 01 | 00 00 03 01 03 00 01 0d |....r...|........|
|000021e0| 00 05 00 0c 00 ae 47 e1 | 7a 54 2a b7 40 00 00 72 |......G.|zT*.@..r|
|000021f0| 01 06 00 04 00 00 00 72 | 01 01 00 0f 00 46 53 55 |.......r|.....FSU|
|00002200| 4d 20 28 42 39 2e 2e 42 | 31 33 29 00 04 01 00 00 |M (B9..B|13).....|
|00002210| 03 01 03 00 01 0f 00 07 | 01 01 00 00 0c 01 01 00 |........|........|
|00002220| 04 02 00 00 00 04 01 00 | 00 03 01 03 00 01 10 00 |........|........|
|00002230| 07 01 01 00 00 0c 01 01 | 00 04 02 00 00 00 04 01 |........|........|
|00002240| 00 00 03 01 03 00 01 11 | 00 07 01 01 00 00 0c 01 |........|........|
|00002250| 01 00 04 02 00 00 00 04 | 01 00 00 03 01 03 00 01 |........|........|
|00002260| 12 00 07 01 01 00 00 0c | 01 01 00 04 02 00 00 00 |........|........|
|00002270| 04 01 00 00 03 01 03 00 | 01 13 00 07 01 01 00 00 |........|........|
|00002280| 0c 01 01 00 04 02 00 00 | 00 04 01 00 00 03 01 03 |........|........|
|00002290| 00 01 14 00 07 01 01 00 | 00 0c 01 01 00 04 02 00 |........|........|
|000022a0| 00 00 04 01 00 00 03 01 | 03 00 01 15 00 07 01 01 |........|........|
|000022b0| 00 00 0c 01 01 00 04 02 | 00 00 00 04 01 00 00 03 |........|........|
|000022c0| 01 03 00 01 16 00 07 01 | 01 00 00 0c 01 01 00 04 |........|........|
|000022d0| 02 00 00 00 04 01 00 00 | 03 01 03 00 01 17 00 07 |........|........|
|000022e0| 01 01 00 00 08 01 01 00 | 01 0c 01 01 00 04 04 00 |........|........|
|000022f0| 0e 00 44 61 74 61 62 61 | 73 65 20 6e 61 6d 65 00 |..Databa|se name.|
|00002300| 04 01 00 00 03 01 03 00 | 01 18 00 07 01 01 00 00 |........|........|
|00002310| 08 01 01 00 01 0c 01 01 | 00 04 04 00 0b 00 54 61 |........|......Ta|
|00002320| 62 6c 65 20 6e 61 6d 65 | 00 04 01 00 00 03 01 03 |ble name|........|
|00002330| 00 01 19 00 07 01 01 00 | 00 08 01 01 00 01 0c 01 |........|........|
|00002340| 01 00 04 04 00 12 00 46 | 69 6c 74 65 72 20 45 78 |.......F|ilter Ex|
|00002350| 70 72 65 73 73 69 6f 6e | 00 04 01 00 00 03 01 03 |pression|........|
|00002360| 00 01 1a 00 07 01 01 00 | 00 08 01 01 00 01 0c 01 |........|........|
|00002370| 01 00 04 04 00 0f 00 44 | 61 74 61 62 61 73 65 20 |.......D|atabase |
|00002380| 46 69 65 6c 64 00 04 01 | 00 00 03 01 03 00 01 1b |Field...|........|
|00002390| 00 07 01 01 00 00 0c 01 | 01 00 04 02 00 00 00 04 |........|........|
|000023a0| 01 00 00 03 01 03 00 01 | 1c 00 07 01 01 00 00 0c |........|........|
|000023b0| 01 01 00 04 02 00 00 00 | 04 01 00 00 03 01 03 00 |........|........|
|000023c0| 01 1d 00 07 01 01 00 00 | 0c 01 01 00 04 02 00 00 |........|........|
|000023d0| 00 04 01 00 00 03 01 03 | 00 01 1e 00 07 01 01 00 |........|........|
|000023e0| 00 0c 01 01 00 04 02 00 | 00 00 04 01 00 00 03 01 |........|........|
|000023f0| 03 00 01 1f 00 07 01 01 | 00 00 0c 01 01 00 04 02 |........|........|
|00002400| 00 00 03 01 03 00 00 1c | 00 07 01 01 00 00 0c 01 |........|........|
|00002410| 01 00 04 04 00 5f 00 54 | 68 69 73 20 72 65 74 75 |....._.T|his retu|
|00002420| 72 6e 73 20 41 4c 4c 20 | 6d 61 74 63 68 69 6e 67 |rns ALL |matching|
|00002430| 20 76 61 6c 75 65 73 20 | 66 72 6f 6d 20 74 68 65 | values |from the|
|00002440| 20 64 61 74 61 62 61 73 | 65 20 2d 20 74 68 69 73 | databas|e - this|
|00002450| 20 77 69 6c 6c 20 6e 6f | 72 6d 61 6c 6c 79 20 62 | will no|rmally b|
|00002460| 65 20 6d 6f 72 65 20 74 | 68 61 6e 20 6f 6e 65 20 |e more t|han one |
|00002470| 76 61 6c 75 65 00 04 01 | 00 00 03 01 03 00 00 1d |value...|........|
|00002480| 00 07 01 01 00 00 0c 01 | 01 00 04 04 00 6a 00 61 |........|.....j.a|
|00002490| 6e 64 20 63 61 6e 20 62 | 65 20 74 72 65 61 74 65 |nd can b|e treate|
|000024a0| 64 20 6c 69 6b 65 20 61 | 6e 79 20 6f 74 68 65 72 |d like a|ny other|
|000024b0| 20 73 65 72 69 65 73 20 | 69 6e 20 61 20 73 70 72 | series |in a spr|
|000024c0| 65 61 64 73 68 65 65 74 | 20 28 69 74 20 63 61 6e |eadsheet| (it can|
|000024d0| 20 62 65 20 73 75 6d 6d | 65 64 2c 20 63 6f 75 6e | be summ|ed, coun|
|000024e0| 74 65 64 2c 20 69 6e 64 | 65 78 65 64 20 61 6e 64 |ted, ind|exed and|
|000024f0| 20 73 6f 20 6f 6e 29 2e | 00 04 01 00 00 03 01 03 | so on).|........|
|00002500| 00 00 1e 00 07 01 01 00 | 00 0c 01 01 00 04 04 00 |........|........|
|00002510| 50 00 49 6e 20 74 68 69 | 73 20 63 61 73 65 20 74 |P.In thi|s case t|
|00002520| 68 65 20 73 74 61 6e 64 | 61 72 64 20 73 70 72 65 |he stand|ard spre|
|00002530| 61 64 73 68 65 65 74 20 | 66 75 6e 63 74 69 6f 6e |adsheet |function|
|00002540| 20 53 55 4d 20 69 73 20 | 75 73 65 64 20 74 6f 20 | SUM is |used to |
|00002550| 74 6f 74 61 6c 20 74 68 | 65 20 73 65 72 69 65 73 |total th|e series|
|00002560| 2e 00 04 01 00 00 03 01 | 03 00 00 1f 00 07 01 01 |........|........|
|00002570| 00 00 0c 01 01 00 04 02 | 00 00 00 04 01 00 00 03 |........|........|
|00002580| 01 03 00 01 07 00 08 01 | 01 00 01 16 01 01 00 02 |........|........|
|00002590| 04 00 04 00 4a 61 6e 00 | 04 01 00 00 03 01 03 00 |....Jan.|........|
|000025a0| 01 08 00 05 00 0c 00 ae | 47 e1 7a 74 3e c4 40 00 |........|G.zt>.@.|
|000025b0| 00 72 01 06 00 04 00 00 | 00 72 01 01 00 60 00 46 |.r......|.r...`.F|
|000025c0| 53 55 4d 20 28 44 42 53 | 51 4c 46 49 4c 54 45 52 |SUM (DBS|QLFILTER|
|000025d0| 20 28 22 53 61 6d 70 6c | 65 2e 61 64 62 22 2c 20 | ("Sampl|e.adb", |
|000025e0| 22 42 61 6e 6b 52 65 63 | 6f 72 64 73 22 2c 20 22 |"BankRec|ords", "|
|000025f0| 54 79 70 65 3d 27 52 65 | 63 65 69 70 74 27 20 41 |Type='Re|ceipt' A|
|00002600| 4e 44 20 6d 6f 6e 74 68 | 28 54 64 61 74 65 29 3d |ND month|(Tdate)=|
|00002610| 31 22 2c 20 22 41 6d 6f | 75 6e 74 22 29 29 00 04 |1", "Amo|unt"))..|
|00002620| 01 00 00 03 01 03 00 01 | 09 00 05 00 0c 00 15 ae |........|........|
|00002630| 47 e1 7a 7f ae c0 00 00 | 72 01 06 00 04 00 00 00 |G.z.....|r.......|
|00002640| 72 01 01 00 65 00 46 53 | 55 4d 20 28 44 42 53 51 |r...e.FS|UM (DBSQ|
|00002650| 4c 46 49 4c 54 45 52 20 | 28 22 53 61 6d 70 6c 65 |LFILTER |("Sample|
|00002660| 2e 61 64 62 22 2c 20 22 | 42 61 6e 6b 52 65 63 6f |.adb", "|BankReco|
|00002670| 72 64 73 22 2c 20 22 54 | 79 70 65 3d 27 44 69 72 |rds", "T|ype='Dir|
|00002680| 65 63 74 20 44 65 62 69 | 74 27 20 41 4e 44 20 6d |ect Debi|t' AND m|
|00002690| 6f 6e 74 68 28 54 64 61 | 74 65 29 3d 31 22 2c 20 |onth(Tda|te)=1", |
|000026a0| 22 41 6d 6f 75 6e 74 22 | 29 29 00 04 01 00 00 03 |"Amount"|))......|
|000026b0| 01 03 00 01 0a 00 05 00 | 0c 00 00 00 00 00 00 00 |........|........|
|000026c0| 69 c0 00 00 72 01 06 00 | 04 00 00 00 72 01 01 00 |i...r...|....r...|
|000026d0| 68 00 46 53 55 4d 20 28 | 44 42 53 51 4c 46 49 4c |h.FSUM (|DBSQLFIL|
|000026e0| 54 45 52 20 28 22 53 61 | 6d 70 6c 65 2e 61 64 62 |TER ("Sa|mple.adb|
|000026f0| 22 2c 20 22 42 61 6e 6b | 52 65 63 6f 72 64 73 22 |", "Bank|Records"|
|00002700| 2c 20 22 54 79 70 65 3d | 27 43 61 73 68 20 57 69 |, "Type=|'Cash Wi|
|00002710| 74 68 64 72 61 77 61 6c | 27 20 41 4e 44 20 6d 6f |thdrawal|' AND mo|
|00002720| 6e 74 68 28 54 64 61 74 | 65 29 3d 31 22 2c 20 22 |nth(Tdat|e)=1", "|
|00002730| 41 6d 6f 75 6e 74 22 29 | 29 00 04 01 00 00 03 01 |Amount")|).......|
|00002740| 03 00 01 0b 00 05 00 0c | 00 3e 0a d7 a3 70 ad 74 |........|.>...p.t|
|00002750| c0 00 00 72 01 06 00 04 | 00 00 00 72 01 01 00 5e |...r....|...r...^|
|00002760| 00 46 53 55 4d 20 28 44 | 42 53 51 4c 46 49 4c 54 |.FSUM (D|BSQLFILT|
|00002770| 45 52 20 28 22 53 61 6d | 70 6c 65 2e 61 64 62 22 |ER ("Sam|ple.adb"|
|00002780| 2c 20 22 42 61 6e 6b 52 | 65 63 6f 72 64 73 22 2c |, "BankR|ecords",|
|00002790| 20 22 54 79 70 65 3d 27 | 43 68 65 63 6b 27 20 41 | "Type='|Check' A|
|000027a0| 4e 44 20 6d 6f 6e 74 68 | 28 54 64 61 74 65 29 3d |ND month|(Tdate)=|
|000027b0| 31 22 2c 20 22 41 6d 6f | 75 6e 74 22 29 29 00 04 |1", "Amo|unt"))..|
|000027c0| 01 00 00 03 01 03 00 01 | 0c 00 02 00 00 00 06 00 |........|........|
|000027d0| 04 00 00 00 72 01 04 01 | 00 00 03 01 03 00 01 0d |....r...|........|
|000027e0| 00 05 00 0c 00 ae 47 e1 | 7a 54 2a b7 40 00 00 72 |......G.|zT*.@..r|
|000027f0| 01 06 00 04 00 00 00 72 | 01 01 00 0f 00 46 53 55 |.......r|.....FSU|
|00002800| 4d 20 28 42 39 2e 2e 42 | 31 33 29 00 04 01 00 00 |M (B9..B|13).....|
|00002810| 03 01 03 00 01 0f 00 07 | 01 01 00 00 0c 01 01 00 |........|........|
|00002820| 04 02 00 00 00 04 01 00 | 00 03 01 03 00 01 10 00 |........|........|
|00002830| 07 01 01 00 00 0c 01 01 | 00 04 02 00 00 00 04 01 |........|........|
|00002840| 00 00 03 01 03 00 01 11 | 00 07 01 01 00 00 0c 01 |........|........|
|00002850| 01 00 04 02 00 00 00 04 | 01 00 00 03 01 03 00 01 |........|........|
|00002860| 12 00 07 01 01 00 00 0c | 01 01 00 04 02 00 00 00 |........|........|
|00002870| 04 01 00 00 03 01 03 00 | 01 13 00 07 01 01 00 00 |........|........|
|00002880| 0c 01 01 00 04 02 00 00 | 00 04 01 00 00 03 01 03 |........|........|
|00002890| 00 01 14 00 07 01 01 00 | 00 0c 01 01 00 04 02 00 |........|........|
|000028a0| 00 00 04 01 00 00 03 01 | 03 00 01 15 00 07 01 01 |........|........|
|000028b0| 00 00 0c 01 01 00 04 02 | 00 00 00 04 01 00 00 03 |........|........|
|000028c0| 01 03 00 01 16 00 07 01 | 01 00 00 0c 01 01 00 04 |........|........|
|000028d0| 02 00 00 00 04 01 00 00 | 03 01 03 00 01 17 00 07 |........|........|
|000028e0| 01 01 00 00 08 01 01 00 | 01 0c 01 01 00 04 04 00 |........|........|
|000028f0| 0e 00 44 61 74 61 62 61 | 73 65 20 6e 61 6d 65 00 |..Databa|se name.|
|00002900| 04 01 00 00 03 01 03 00 | 01 18 00 07 01 01 00 00 |........|........|
|00002910| 08 01 01 00 01 0c 01 01 | 00 04 04 00 0b 00 54 61 |........|......Ta|
|00002920| 62 6c 65 20 6e 61 6d 65 | 00 04 01 00 00 03 01 03 |ble name|........|
|00002930| 00 01 19 00 07 01 01 00 | 00 08 01 01 00 01 0c 01 |........|........|
|00002940| 01 00 04 04 00 12 00 46 | 69 6c 74 65 72 20 45 78 |.......F|ilter Ex|
|00002950| 70 72 65 73 73 69 6f 6e | 00 04 01 00 00 03 01 03 |pression|........|
|00002960| 00 01 1a 00 07 01 01 00 | 00 08 01 01 00 01 0c 01 |........|........|
|00002970| 01 00 04 04 00 0f 00 44 | 61 74 61 62 61 73 65 20 |.......D|atabase |
|00002980| 46 69 65 6c 64 00 04 01 | 00 00 03 01 03 00 01 1b |Field...|........|
|00002990| 00 07 01 01 00 00 0c 01 | 01 00 04 02 00 00 00 04 |........|........|
|000029a0| 01 00 00 03 01 03 00 01 | 1c 00 07 01 01 00 00 0c |........|........|
|000029b0| 01 01 00 04 02 00 00 00 | 04 01 00 00 03 01 03 00 |........|........|
|000029c0| 01 1d 00 07 01 01 00 00 | 0c 01 01 00 04 02 00 00 |........|........|
|000029d0| 00 04 01 00 00 03 01 03 | 00 01 1e 00 07 01 01 00 |........|........|
|000029e0| 00 0c 01 01 00 04 02 00 | 00 00 04 01 00 00 03 01 |........|........|
|000029f0| 03 00 01 1f 00 07 01 01 | 00 00 0c 01 01 00 04 02 |........|........|
|00002a00| 00 00 00 04 01 00 00 03 | 01 03 00 02 07 00 08 01 |........|........|
|00002a10| 01 00 01 16 01 01 00 02 | 04 00 04 00 46 65 62 00 |........|....Feb.|
|00002a20| 04 01 00 00 03 01 03 00 | 02 08 00 05 00 0c 00 ce |........|........|
|00002a30| cc cc cc ec ad cd 40 00 | 00 72 01 06 00 04 00 00 |......@.|.r......|
|00002a40| 00 72 01 01 00 60 00 46 | 53 55 4d 20 28 44 42 53 |.r...`.F|SUM (DBS|
|00002a50| 51 4c 46 49 4c 54 45 52 | 20 28 22 53 61 6d 70 6c |QLFILTER| ("Sampl|
|00002a60| 65 2e 61 64 62 22 2c 20 | 22 42 61 6e 6b 52 65 63 |e.adb", |"BankRec|
|00002a70| 6f 72 64 73 22 2c 20 22 | 54 79 70 65 3d 27 52 65 |ords", "|Type='Re|
|00002a80| 63 65 69 70 74 27 20 41 | 4e 44 20 6d 6f 6e 74 68 |ceipt' A|ND month|
|00002a90| 28 54 64 61 74 65 29 3d | 32 22 2c 20 22 41 6d 6f |(Tdate)=|2", "Amo|
|00002aa0| 75 6e 74 22 29 29 00 04 | 01 00 00 03 01 03 00 02 |unt"))..|........|
|00002ab0| 09 00 05 00 0c 00 eb 51 | b8 1e 85 a6 a8 c0 00 00 |.......Q|........|
|00002ac0| 72 01 06 00 04 00 00 00 | 72 01 01 00 65 00 46 53 |r.......|r...e.FS|
|00002ad0| 55 4d 20 28 44 42 53 51 | 4c 46 49 4c 54 45 52 20 |UM (DBSQ|LFILTER |
|00002ae0| 28 22 53 61 6d 70 6c 65 | 2e 61 64 62 22 2c 20 22 |("Sample|.adb", "|
|00002af0| 42 61 6e 6b 52 65 63 6f | 72 64 73 22 2c 20 22 54 |BankReco|rds", "T|
|00002b00| 79 70 65 3d 27 44 69 72 | 65 63 74 20 44 65 62 69 |ype='Dir|ect Debi|
|00002b10| 74 27 20 41 4e 44 20 6d | 6f 6e 74 68 28 54 64 61 |t' AND m|onth(Tda|
|00002b20| 74 65 29 3d 32 22 2c 20 | 22 41 6d 6f 75 6e 74 22 |te)=2", |"Amount"|
|00002b30| 29 29 00 04 01 00 00 03 | 01 03 00 02 0a 00 05 00 |))......|........|
|00002b40| 0c 00 00 00 00 00 00 00 | 59 c0 00 00 72 01 06 00 |........|Y...r...|
|00002b50| 04 00 00 00 72 01 01 00 | 68 00 46 53 55 4d 20 28 |....r...|h.FSUM (|
|00002b60| 44 42 53 51 4c 46 49 4c | 54 45 52 20 28 22 53 61 |DBSQLFIL|TER ("Sa|
|00002b70| 6d 70 6c 65 2e 61 64 62 | 22 2c 20 22 42 61 6e 6b |mple.adb|", "Bank|
|00002b80| 52 65 63 6f 72 64 73 22 | 2c 20 22 54 79 70 65 3d |Records"|, "Type=|
|00002b90| 27 43 61 73 68 20 57 69 | 74 68 64 72 61 77 61 6c |'Cash Wi|thdrawal|
|00002ba0| 27 20 41 4e 44 20 6d 6f | 6e 74 68 28 54 64 61 74 |' AND mo|nth(Tdat|
|00002bb0| 65 29 3d 32 22 2c 20 22 | 41 6d 6f 75 6e 74 22 29 |e)=2", "|Amount")|
|00002bc0| 29 00 04 01 00 00 03 01 | 03 00 02 0b 00 05 00 0c |).......|........|
|00002bd0| 00 3d 0a d7 a3 70 1d 4f | c0 00 00 72 01 06 00 04 |.=...p.O|...r....|
|00002be0| 00 00 00 72 01 01 00 5e | 00 46 53 55 4d 20 28 44 |...r...^|.FSUM (D|
|00002bf0| 42 53 51 4c 46 49 4c 54 | 45 52 20 28 22 53 61 6d |BSQLFILT|ER ("Sam|
|00002c00| 70 6c 65 2e 61 64 62 22 | 2c 20 22 42 61 6e 6b 52 |ple.adb"|, "BankR|
|00002c10| 65 63 6f 72 64 73 22 2c | 20 22 54 79 70 65 3d 27 |ecords",| "Type='|
|00002c20| 43 68 65 63 6b 27 20 41 | 4e 44 20 6d 6f 6e 74 68 |Check' A|ND month|
|00002c30| 28 54 64 61 74 65 29 3d | 32 22 2c 20 22 41 6d 6f |(Tdate)=|2", "Amo|
|00002c40| 75 6e 74 22 29 29 00 04 | 01 00 00 03 01 03 00 02 |unt"))..|........|
|00002c50| 0c 00 02 00 00 00 06 00 | 04 00 00 00 72 01 04 01 |........|....r...|
|00002c60| 00 00 03 01 03 00 02 0d | 00 05 00 0c 00 49 e1 7a |........|.....I.z|
|00002c70| 14 2e 33 c7 40 00 00 72 | 01 06 00 04 00 00 00 72 |..3.@..r|.......r|
|00002c80| 01 01 00 0f 00 46 53 55 | 4d 20 28 43 39 2e 2e 43 |.....FSU|M (C9..C|
|00002c90| 31 33 29 00 04 01 00 00 | 03 01 03 00 02 0f 00 07 |13).....|........|
|00002ca0| 01 01 00 00 0c 01 01 00 | 04 02 00 00 00 04 01 00 |........|........|
|00002cb0| 00 03 01 03 00 02 10 00 | 07 01 01 00 00 0c 01 01 |........|........|
|00002cc0| 00 04 02 00 00 00 04 01 | 00 00 03 01 03 00 02 11 |........|........|
|00002cd0| 00 07 01 01 00 00 0c 01 | 01 00 04 02 00 00 00 04 |........|........|
|00002ce0| 01 00 00 03 01 03 00 02 | 12 00 07 01 01 00 00 0c |........|........|
|00002cf0| 01 01 00 04 02 00 00 00 | 04 01 00 00 03 01 03 00 |........|........|
|00002d00| 02 13 00 07 01 01 00 00 | 0c 01 01 00 04 02 00 00 |........|........|
|00002d10| 00 04 01 00 00 03 01 03 | 00 02 14 00 07 01 01 00 |........|........|
|00002d20| 00 0c 01 01 00 04 02 00 | 00 00 04 01 00 00 03 01 |........|........|
|00002d30| 03 00 02 15 00 07 01 01 | 00 00 0c 01 01 00 04 02 |........|........|
|00002d40| 00 00 00 04 01 00 00 03 | 01 03 00 02 16 00 07 01 |........|........|
|00002d50| 01 00 00 0c 01 01 00 04 | 02 00 00 00 04 01 00 00 |........|........|
|00002d60| 03 01 03 00 02 17 00 07 | 01 01 00 00 0c 01 01 00 |........|........|
|00002d70| 04 02 00 00 00 04 01 00 | 00 03 01 03 00 02 18 00 |........|........|
|00002d80| 07 01 01 00 00 0c 01 01 | 00 04 02 00 00 00 04 01 |........|........|
|00002d90| 00 00 03 01 03 00 02 19 | 00 07 01 01 00 00 0c 01 |........|........|
|00002da0| 01 00 04 02 00 00 00 04 | 01 00 00 03 01 03 00 02 |........|........|
|00002db0| 1a 00 07 01 01 00 00 0c | 01 01 00 04 02 00 00 00 |........|........|
|00002dc0| 04 01 00 00 03 01 03 00 | 02 1b 00 07 01 01 00 00 |........|........|
|00002dd0| 0c 01 01 00 04 02 00 00 | 00 04 01 00 00 03 01 03 |........|........|
|00002de0| 00 02 1c 00 07 01 01 00 | 00 0c 01 01 00 04 02 00 |........|........|
|00002df0| 00 00 04 01 00 00 03 01 | 03 00 02 1d 00 07 01 01 |........|........|
|00002e00| 00 00 00 04 01 00 00 03 | 01 03 00 02 07 00 08 01 |........|........|
|00002e10| 01 00 01 16 01 01 00 02 | 04 00 04 00 46 65 62 00 |........|....Feb.|
|00002e20| 04 01 00 00 03 01 03 00 | 02 08 00 05 00 0c 00 ce |........|........|
|00002e30| cc cc cc ec ad cd 40 00 | 00 72 01 06 00 04 00 00 |......@.|.r......|
|00002e40| 00 72 01 01 00 60 00 46 | 53 55 4d 20 28 44 42 53 |.r...`.F|SUM (DBS|
|00002e50| 51 4c 46 49 4c 54 45 52 | 20 28 22 53 61 6d 70 6c |QLFILTER| ("Sampl|
|00002e60| 65 2e 61 64 62 22 2c 20 | 22 42 61 6e 6b 52 65 63 |e.adb", |"BankRec|
|00002e70| 6f 72 64 73 22 2c 20 22 | 54 79 70 65 3d 27 52 65 |ords", "|Type='Re|
|00002e80| 63 65 69 70 74 27 20 41 | 4e 44 20 6d 6f 6e 74 68 |ceipt' A|ND month|
|00002e90| 28 54 64 61 74 65 29 3d | 32 22 2c 20 22 41 6d 6f |(Tdate)=|2", "Amo|
|00002ea0| 75 6e 74 22 29 29 00 04 | 01 00 00 03 01 03 00 02 |unt"))..|........|
|00002eb0| 09 00 05 00 0c 00 eb 51 | b8 1e 85 a6 a8 c0 00 00 |.......Q|........|
|00002ec0| 72 01 06 00 04 00 00 00 | 72 01 01 00 65 00 46 53 |r.......|r...e.FS|
|00002ed0| 55 4d 20 28 44 42 53 51 | 4c 46 49 4c 54 45 52 20 |UM (DBSQ|LFILTER |
|00002ee0| 28 22 53 61 6d 70 6c 65 | 2e 61 64 62 22 2c 20 22 |("Sample|.adb", "|
|00002ef0| 42 61 6e 6b 52 65 63 6f | 72 64 73 22 2c 20 22 54 |BankReco|rds", "T|
|00002f00| 79 70 65 3d 27 44 69 72 | 65 63 74 20 44 65 62 69 |ype='Dir|ect Debi|
|00002f10| 74 27 20 41 4e 44 20 6d | 6f 6e 74 68 28 54 64 61 |t' AND m|onth(Tda|
|00002f20| 74 65 29 3d 32 22 2c 20 | 22 41 6d 6f 75 6e 74 22 |te)=2", |"Amount"|
|00002f30| 29 29 00 04 01 00 00 03 | 01 03 00 02 0a 00 05 00 |))......|........|
|00002f40| 0c 00 00 00 00 00 00 00 | 59 c0 00 00 72 01 06 00 |........|Y...r...|
|00002f50| 04 00 00 00 72 01 01 00 | 68 00 46 53 55 4d 20 28 |....r...|h.FSUM (|
|00002f60| 44 42 53 51 4c 46 49 4c | 54 45 52 20 28 22 53 61 |DBSQLFIL|TER ("Sa|
|00002f70| 6d 70 6c 65 2e 61 64 62 | 22 2c 20 22 42 61 6e 6b |mple.adb|", "Bank|
|00002f80| 52 65 63 6f 72 64 73 22 | 2c 20 22 54 79 70 65 3d |Records"|, "Type=|
|00002f90| 27 43 61 73 68 20 57 69 | 74 68 64 72 61 77 61 6c |'Cash Wi|thdrawal|
|00002fa0| 27 20 41 4e 44 20 6d 6f | 6e 74 68 28 54 64 61 74 |' AND mo|nth(Tdat|
|00002fb0| 65 29 3d 32 22 2c 20 22 | 41 6d 6f 75 6e 74 22 29 |e)=2", "|Amount")|
|00002fc0| 29 00 04 01 00 00 03 01 | 03 00 02 0b 00 05 00 0c |).......|........|
|00002fd0| 00 3d 0a d7 a3 70 1d 4f | c0 00 00 72 01 06 00 04 |.=...p.O|...r....|
|00002fe0| 00 00 00 72 01 01 00 5e | 00 46 53 55 4d 20 28 44 |...r...^|.FSUM (D|
|00002ff0| 42 53 51 4c 46 49 4c 54 | 45 52 20 28 22 53 61 6d |BSQLFILT|ER ("Sam|
|00003000| 70 6c 65 2e 61 64 62 22 | 2c 20 22 42 61 6e 6b 52 |ple.adb"|, "BankR|
|00003010| 65 63 6f 72 64 73 22 2c | 20 22 54 79 70 65 3d 27 |ecords",| "Type='|
|00003020| 43 68 65 63 6b 27 20 41 | 4e 44 20 6d 6f 6e 74 68 |Check' A|ND month|
|00003030| 28 54 64 61 74 65 29 3d | 32 22 2c 20 22 41 6d 6f |(Tdate)=|2", "Amo|
|00003040| 75 6e 74 22 29 29 00 04 | 01 00 00 03 01 03 00 02 |unt"))..|........|
|00003050| 0c 00 02 00 00 00 06 00 | 04 00 00 00 72 01 04 01 |........|....r...|
|00003060| 00 00 03 01 03 00 02 0d | 00 05 00 0c 00 49 e1 7a |........|.....I.z|
|00003070| 14 2e 33 c7 40 00 00 72 | 01 06 00 04 00 00 00 72 |..3.@..r|.......r|
|00003080| 01 01 00 0f 00 46 53 55 | 4d 20 28 43 39 2e 2e 43 |.....FSU|M (C9..C|
|00003090| 31 33 29 00 04 01 00 00 | 03 01 03 00 02 0f 00 07 |13).....|........|
|000030a0| 01 01 00 00 0c 01 01 00 | 04 02 00 00 00 04 01 00 |........|........|
|000030b0| 00 03 01 03 00 02 10 00 | 07 01 01 00 00 0c 01 01 |........|........|
|000030c0| 00 04 02 00 00 00 04 01 | 00 00 03 01 03 00 02 11 |........|........|
|000030d0| 00 07 01 01 00 00 0c 01 | 01 00 04 02 00 00 00 04 |........|........|
|000030e0| 01 00 00 03 01 03 00 02 | 12 00 07 01 01 00 00 0c |........|........|
|000030f0| 01 01 00 04 02 00 00 00 | 04 01 00 00 03 01 03 00 |........|........|
|00003100| 02 13 00 07 01 01 00 00 | 0c 01 01 00 04 02 00 00 |........|........|
|00003110| 00 04 01 00 00 03 01 03 | 00 02 14 00 07 01 01 00 |........|........|
|00003120| 00 0c 01 01 00 04 02 00 | 00 00 04 01 00 00 03 01 |........|........|
|00003130| 03 00 02 15 00 07 01 01 | 00 00 0c 01 01 00 04 02 |........|........|
|00003140| 00 00 00 04 01 00 00 03 | 01 03 00 02 16 00 07 01 |........|........|
|00003150| 01 00 00 0c 01 01 00 04 | 02 00 00 00 04 01 00 00 |........|........|
|00003160| 03 01 03 00 02 17 00 07 | 01 01 00 00 0c 01 01 00 |........|........|
|00003170| 04 02 00 00 00 04 01 00 | 00 03 01 03 00 02 18 00 |........|........|
|00003180| 07 01 01 00 00 0c 01 01 | 00 04 02 00 00 00 04 01 |........|........|
|00003190| 00 00 03 01 03 00 02 19 | 00 07 01 01 00 00 0c 01 |........|........|
|000031a0| 01 00 04 02 00 00 00 04 | 01 00 00 03 01 03 00 02 |........|........|
|000031b0| 1a 00 07 01 01 00 00 0c | 01 01 00 04 02 00 00 00 |........|........|
|000031c0| 04 01 00 00 03 01 03 00 | 02 1b 00 07 01 01 00 00 |........|........|
|000031d0| 0c 01 01 00 04 02 00 00 | 00 04 01 00 00 03 01 03 |........|........|
|000031e0| 00 02 1c 00 07 01 01 00 | 00 0c 01 01 00 04 02 00 |........|........|
|000031f0| 00 00 04 01 00 00 03 01 | 03 00 02 1d 00 07 01 01 |........|........|
|00003200| 00 00 0c 01 01 00 04 02 | 00 00 00 04 01 00 00 03 |........|........|
|00003210| 01 03 00 02 1e 00 07 01 | 01 00 00 0c 01 01 00 04 |........|........|
|00003220| 02 00 00 00 04 01 00 00 | 03 01 03 00 02 1f 00 07 |........|........|
|00003230| 01 01 00 00 0c 01 01 00 | 04 02 00 00 00 04 01 00 |........|........|
|00003240| 00 03 01 03 00 03 07 00 | 08 01 01 00 01 16 01 01 |........|........|
|00003250| 00 02 04 00 04 00 4d 61 | 72 00 04 01 00 00 03 01 |......Ma|r.......|
|00003260| 03 00 03 08 00 05 00 0c | 00 1e 85 eb 51 f8 10 ce |........|....Q...|
|00003270| 40 00 00 72 01 06 00 04 | 00 00 00 72 01 01 00 60 |@..r....|...r...`|
|00003280| 00 46 53 55 4d 20 28 44 | 42 53 51 4c 46 49 4c 54 |.FSUM (D|BSQLFILT|
|00003290| 45 52 20 28 22 53 61 6d | 70 6c 65 2e 61 64 62 22 |ER ("Sam|ple.adb"|
|000032a0| 2c 20 22 42 61 6e 6b 52 | 65 63 6f 72 64 73 22 2c |, "BankR|ecords",|
|000032b0| 20 22 54 79 70 65 3d 27 | 52 65 63 65 69 70 74 27 | "Type='|Receipt'|
|000032c0| 20 41 4e 44 20 6d 6f 6e | 74 68 28 54 64 61 74 65 | AND mon|th(Tdate|
|000032d0| 29 3d 33 22 2c 20 22 41 | 6d 6f 75 6e 74 22 29 29 |)=3", "A|mount"))|
|000032e0| 00 04 01 00 00 03 01 03 | 00 03 09 00 05 00 0c 00 |........|........|
|000032f0| 66 66 66 66 e6 47 ab c0 | 00 00 72 01 06 00 04 00 |ffff.G..|..r.....|
|00003300| 00 00 72 01 01 00 65 00 | 46 53 55 4d 20 28 44 42 |..r...e.|FSUM (DB|
|00003310| 53 51 4c 46 49 4c 54 45 | 52 20 28 22 53 61 6d 70 |SQLFILTE|R ("Samp|
|00003320| 6c 65 2e 61 64 62 22 2c | 20 22 42 61 6e 6b 52 65 |le.adb",| "BankRe|
|00003330| 63 6f 72 64 73 22 2c 20 | 22 54 79 70 65 3d 27 44 |cords", |"Type='D|
|00003340| 69 72 65 63 74 20 44 65 | 62 69 74 27 20 41 4e 44 |irect De|bit' AND|
|00003350| 20 6d 6f 6e 74 68 28 54 | 64 61 74 65 29 3d 33 22 | month(T|date)=3"|
|00003360| 2c 20 22 41 6d 6f 75 6e | 74 22 29 29 00 04 01 00 |, "Amoun|t"))....|
|00003370| 00 03 01 03 00 03 0a 00 | 05 00 0c 00 00 00 00 00 |........|........|
|00003380| 00 c0 72 c0 00 00 72 01 | 06 00 04 00 00 00 72 01 |..r...r.|......r.|
|00003390| 01 00 68 00 46 53 55 4d | 20 28 44 42 53 51 4c 46 |..h.FSUM| (DBSQLF|
|000033a0| 49 4c 54 45 52 20 28 22 | 53 61 6d 70 6c 65 2e 61 |ILTER ("|Sample.a|
|000033b0| 64 62 22 2c 20 22 42 61 | 6e 6b 52 65 63 6f 72 64 |db", "Ba|nkRecord|
|000033c0| 73 22 2c 20 22 54 79 70 | 65 3d 27 43 61 73 68 20 |s", "Typ|e='Cash |
|000033d0| 57 69 74 68 64 72 61 77 | 61 6c 27 20 41 4e 44 20 |Withdraw|al' AND |
|000033e0| 6d 6f 6e 74 68 28 54 64 | 61 74 65 29 3d 33 22 2c |month(Td|ate)=3",|
|000033f0| 20 22 41 6d 6f 75 6e 74 | 22 29 29 00 04 01 00 00 | "Amount|")).....|
|00003400| 03 01 03 00 03 0b 00 05 | 00 0c 00 52 b8 1e 85 eb |........|...R....|
|00003410| d1 47 c0 00 00 72 01 06 | 00 04 00 00 00 72 01 01 |.G...r..|.....r..|
|00003420| 00 5e 00 46 53 55 4d 20 | 28 44 42 53 51 4c 46 49 |.^.FSUM |(DBSQLFI|
|00003430| 4c 54 45 52 20 28 22 53 | 61 6d 70 6c 65 2e 61 64 |LTER ("S|ample.ad|
|00003440| 62 22 2c 20 22 42 61 6e | 6b 52 65 63 6f 72 64 73 |b", "Ban|kRecords|
|00003450| 22 2c 20 22 54 79 70 65 | 3d 27 43 68 65 63 6b 27 |", "Type|='Check'|
|00003460| 20 41 4e 44 20 6d 6f 6e | 74 68 28 54 64 61 74 65 | AND mon|th(Tdate|
|00003470| 29 3d 33 22 2c 20 22 41 | 6d 6f 75 6e 74 22 29 29 |)=3", "A|mount"))|
|00003480| 00 04 01 00 00 03 01 03 | 00 03 0c 00 02 00 00 00 |........|........|
|00003490| 06 00 04 00 00 00 72 01 | 04 01 00 00 03 01 03 00 |......r.|........|
|000034a0| 03 0d 00 05 00 0c 00 cc | cc cc cc 2c 91 c6 40 00 |........|...,..@.|
|000034b0| 00 72 01 06 00 04 00 00 | 00 72 01 01 00 0f 00 46 |.r......|.r.....F|
|000034c0| 53 55 4d 20 28 44 39 2e | 2e 44 31 33 29 00 04 01 |SUM (D9.|.D13)...|
|000034d0| 00 00 03 01 03 00 03 0f | 00 07 01 01 00 00 0c 01 |........|........|
|000034e0| 01 00 04 02 00 00 00 04 | 01 00 00 03 01 03 00 03 |........|........|
|000034f0| 10 00 07 01 01 00 00 0c | 01 01 00 04 02 00 00 00 |........|........|
|00003500| 04 01 00 00 03 01 03 00 | 03 11 00 07 01 01 00 00 |........|........|
|00003510| 0c 01 01 00 04 02 00 00 | 00 04 01 00 00 03 01 03 |........|........|
|00003520| 00 03 12 00 07 01 01 00 | 00 0c 01 01 00 04 02 00 |........|........|
|00003530| 00 00 04 01 00 00 03 01 | 03 00 03 13 00 07 01 01 |........|........|
|00003540| 00 00 0c 01 01 00 04 02 | 00 00 00 04 01 00 00 03 |........|........|
|00003550| 01 03 00 03 14 00 07 01 | 01 00 00 0c 01 01 00 04 |........|........|
|00003560| 02 00 00 00 04 01 00 00 | 03 01 03 00 03 15 00 07 |........|........|
|00003570| 01 01 00 00 0c 01 01 00 | 04 02 00 00 00 04 01 00 |........|........|
|00003580| 00 03 01 03 00 03 16 00 | 07 01 01 00 00 0c 01 01 |........|........|
|00003590| 00 04 02 00 00 00 04 01 | 00 00 03 01 03 00 03 17 |........|........|
|000035a0| 00 07 01 01 00 00 0c 01 | 01 00 04 04 00 0b 00 53 |........|.......S|
|000035b0| 61 6d 70 6c 65 2e 61 64 | 62 00 04 01 00 00 03 01 |ample.ad|b.......|
|000035c0| 03 00 03 18 00 07 01 01 | 00 00 0c 01 01 00 04 04 |........|........|
|000035d0| 00 0c 00 42 61 6e 6b 52 | 65 63 6f 72 64 73 00 04 |...BankR|ecords..|
|000035e0| 01 00 00 03 01 03 00 03 | 19 00 07 01 01 00 00 0c |........|........|
|000035f0| 01 01 00 04 04 00 22 00 | 54 79 70 65 3d 27 52 65 |......".|Type='Re|
|00003600| 63 65 69 70 74 27 20 41 | 4e 44 20 6d 6f 6e 74 68 |ceipt' A|ND month|
|00003610| 28 54 64 61 74 65 29 3d | 32 00 04 01 00 00 03 01 |(Tdate)=|2.......|
|00003620| 03 00 03 1a 00 07 01 01 | 00 00 0c 01 01 00 04 04 |........|........|
|00003630| 00 07 00 41 6d 6f 75 6e | 74 00 04 01 00 00 03 01 |...Amoun|t.......|
|00003640| 03 00 03 1b 00 07 01 01 | 00 00 0c 01 01 00 04 02 |........|........|
|00003650| 00 00 00 04 01 00 00 03 | 01 03 00 03 1c 00 07 01 |........|........|
|00003660| 01 00 00 0c 01 01 00 04 | 02 00 00 00 04 01 00 00 |........|........|
|00003670| 03 01 03 00 03 1d 00 07 | 01 01 00 00 0c 01 01 00 |........|........|
|00003680| 04 02 00 00 00 04 01 00 | 00 03 01 03 00 03 1e 00 |........|........|
|00003690| 07 01 01 00 00 0c 01 01 | 00 04 02 00 00 00 04 01 |........|........|
|000036a0| 00 00 03 01 03 00 03 1f | 00 07 01 01 00 00 0c 01 |........|........|
|000036b0| 01 00 04 02 00 00 00 04 | 01 00 00 03 01 03 00 04 |........|........|
|000036c0| 07 00 08 01 01 00 01 09 | 01 01 00 02 16 01 01 00 |........|........|
|000036d0| 02 04 00 0b 00 51 74 72 | 20 54 6f 74 61 6c 73 00 |.....Qtr| Totals.|
|000036e0| 04 01 00 00 03 01 03 00 | 04 08 00 09 01 01 00 02 |........|........|
|000036f0| 05 00 0c 00 66 66 66 66 | 56 ff e3 40 00 00 72 01 |....ffff|V..@..r.|
|00003700| 06 00 04 00 00 00 72 01 | 01 00 0e 00 46 53 55 4d |......r.|....FSUM|
|00003710| 20 28 42 39 2e 2e 44 39 | 29 00 04 01 00 00 03 01 | (B9..D9|).......|
|00003720| 03 00 04 09 00 09 01 01 | 00 02 05 00 0c 00 9a 99 |........|........|
|00003730| 99 99 79 9b c4 c0 00 00 | 72 01 06 00 04 00 00 00 |..y.....|r.......|
|00003740| 72 01 01 00 10 00 46 53 | 55 4d 20 28 42 31 30 2e |r.....FS|UM (B10.|
|00003750| 2e 44 31 30 29 00 04 01 | 00 00 03 01 03 00 04 0a |.D10)...|........|
|00003760| 00 09 01 01 00 02 05 00 | 0c 00 00 00 00 00 00 c0 |........|........|
|00003770| 82 c0 00 00 72 01 06 00 | 04 00 00 00 72 01 01 00 |....r...|....r...|
|00003780| 10 00 46 53 55 4d 20 28 | 42 31 31 2e 2e 44 31 31 |..FSUM (|B11..D11|
|00003790| 29 00 04 01 00 00 03 01 | 03 00 04 0b 00 09 01 01 |).......|........|
|000037a0| 00 02 05 00 0c 00 90 c2 | f5 28 5c 8b 7b c0 00 00 |........|.(\.{...|
|000037b0| 72 01 06 00 04 00 00 00 | 72 01 01 00 10 00 46 53 |r.......|r.....FS|
|000037c0| 55 4d 20 28 42 31 32 2e | 2e 44 31 32 29 00 04 01 |UM (B12.|.D12)...|
|000037d0| 00 00 03 01 03 00 04 0c | 00 09 01 01 00 02 02 00 |........|........|
|000037e0| 00 00 06 00 04 00 00 00 | 72 01 04 01 00 00 03 01 |........|r.......|
|000037f0| 03 00 04 0d 00 09 01 01 | 00 02 05 00 0c 00 f5 28 |........|.......(|
|00003800| 5c 8f c2 ac dc 40 00 00 | 72 01 06 00 04 00 00 00 |\....@..|r.......|
|00003810| 72 01 01 00 0f 00 46 53 | 55 4d 20 28 45 39 2e 2e |r.....FS|UM (E9..|
|00003820| 45 31 33 29 00 04 01 00 | 00 03 01 03 00 05 07 00 |E13)....|........|
|00003830| 08 01 01 00 01 16 01 01 | 00 02 04 00 0a 00 41 76 |........|......Av|
|00003840| 67 2f 4d 6f 6e 74 68 00 | 04 01 00 00 03 01 03 00 |g/Month.|........|
|00003850| 05 08 00 05 00 0c 00 88 | 88 88 88 c8 a9 ca 40 00 |........|......@.|
|00003860| 00 72 01 06 00 04 00 00 | 00 72 01 01 00 0e 00 46 |.r......|.r.....F|
|00003870| 41 56 47 20 28 42 39 2e | 2e 44 39 29 00 04 01 00 |AVG (B9.|.D9)....|
|00003880| 00 03 01 03 00 05 09 00 | 05 00 0c 00 78 77 77 77 |........|....xwww|
|00003890| f7 79 ab c0 00 00 72 01 | 06 00 04 00 00 00 72 01 |.y....r.|......r.|
|000038a0| 01 00 10 00 46 41 56 47 | 20 28 42 31 30 2e 2e 44 |....FAVG| (B10..D|
|000038b0| 31 30 29 00 04 01 00 00 | 03 01 03 00 05 0a 00 05 |10).....|........|
|000038c0| 00 0c 00 00 00 00 00 00 | 00 69 c0 00 00 72 01 06 |........|.i...r..|
|000038d0| 00 04 00 00 00 72 01 01 | 00 10 00 46 41 56 47 20 |.....r..|...FAVG |
|000038e0| 28 42 31 31 2e 2e 44 31 | 31 29 00 04 01 00 00 03 |(B11..D1|1)......|
|000038f0| 01 03 00 05 0b 00 05 00 | 0c 00 b5 81 4e 1b e8 5c |........|....N..\|
|00003900| 62 c0 00 00 72 01 06 00 | 04 00 00 00 72 01 01 00 |b...r...|....r...|
|00003910| 10 00 46 41 56 47 20 28 | 42 31 32 2e 2e 44 31 32 |..FAVG (|B12..D12|
|00003920| 29 00 04 01 00 00 03 01 | 03 00 05 0c 00 02 00 00 |).......|........|
|00003930| 00 06 00 04 00 00 00 72 | 01 04 01 00 00 03 01 03 |.......r|........|
|00003940| 00 05 0d 00 05 00 0c 00 | a4 70 3d 0a d7 1d c3 40 |........|.p=....@|
|00003950| 00 00 72 01 06 00 04 00 | 00 00 72 01 01 00 10 00 |..r.....|..r.....|
|00003960| 46 41 56 47 20 28 42 31 | 34 2e 2e 44 31 34 29 00 |FAVG (B1|4..D14).|
|00003970| 04 01 00 00 32 01 00 00 | 33 01 2c 00 2c 00 00 00 |....2...|3.,.,...|
|00003980| 00 00 00 00 01 00 00 00 | ff ff ff ff ff ff ff ff |........|........|
|00003990| ff ff ff ff ff ff ff ff | 00 00 00 00 00 00 00 00 |........|........|
|000039a0| 0a 02 00 00 bb 00 00 00 | 34 01 08 00 ee 01 00 00 |........|4.......|
|000039b0| 50 00 00 00 35 01 08 00 | 8c 00 00 00 10 00 00 00 |P...5...|........|
|000039c0| 37 01 0c 00 01 00 00 00 | 00 00 00 00 00 00 00 00 |7.......|........|
|000039d0| 38 01 01 00 01 3a 01 10 | 00 00 00 00 00 07 00 00 |8....:..|........|
|000039e0| 00 04 00 00 00 0d 00 00 | 00 3b 01 08 00 00 00 00 |........|.;......|
|000039f0| 00 07 00 00 00 3d 01 08 | 00 00 00 00 00 05 00 00 |.....=..|........|
|00003a00| 00 3f 01 08 00 07 00 00 | 00 0e 00 00 00 40 01 00 |.?......|.....@..|
|00003a10| 00 36 01 00 00 01 01 00 | 00 00 00 00 00 00 00 00 |.6......|........|
|00003a20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ac0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ad0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ae0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003af0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003b90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ba0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003bb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003bc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003bd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003bf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
+--------+-------------------------+-------------------------+--------+--------+